home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / dayofweek.sql < prev    next >
Text File  |  2000-05-12  |  812b  |  27 lines
  1. /* RCSVER $Id: dayofweek.sql,v 1.2 2000-01-25 16:33:24-06 randy Exp $ */
  2. /* *************************************************************************
  3. *        Copyright (C) 1999, Agent Systems, Inc. All Rights Reserved.
  4. *
  5. * Name:        dayofweek.sql
  6. * Date:        01/17/2000
  7. * memo:        Randy Wood
  8. * Description:    Create the dayofweek table.
  9. *            Days are as follows:
  10. *            0: All
  11. *            1: Sunday
  12. *            2: Monday
  13. *            3: Tuesday
  14. *            4: Wednesday
  15. *            5: Thursday
  16. *            6: Friday
  17. *            7: Saturday
  18. *            8: Weekend (Sat/Sun)
  19. *            9: Weekday (Mon-Fri)
  20. * Changes:
  21. ************************************************************************* */
  22. CREATE TABLE dayofweek
  23. (
  24.     num NUMBER(38),         /* Integer value for day of week */
  25.     descr VARCHAR2(10),    /* Description of day of week */
  26.     CONSTRAINT pk_dayofweek PRIMARY KEY(num)
  27. );